Spread Windows Forms 10.0 Product Documentation
GetDependents(Dictionary<String,FormulaDependentInfos>,String,Int32,Int32,Boolean,Boolean,Boolean,Boolean) Method


Dictionary of FormulaDependentInfos object that contains all the infomation of all the dependent formula containers. The key in using the dictionary is the data model name that has dependent formula containers.
Name of the specified table.
Table column start index.
Table column end index.
Indicates whether to get all dependent cells.
Indicates whether to get all dependent rows.
Indicates whether to get all dependent columns.
Indicates whether to get all dependent expression consumer objects.
Gets all the formula containers that have formulas referring to the specified table when params tableColumnStartIndex and tableColumnEndIndex are both equal to -1, or gets all the formula containers that have formulas explicitly referring to the table columns in the specified range limit by params tableColumnStartIndex and tableColumnEndIndex.
Syntax
'Declaration
 
Overloads Sub GetDependents( _
   ByVal infoDict As Dictionary(Of String,FormulaDependentInfos), _
   ByVal tableName As String, _
   ByVal tableColumnStartIndex As Integer, _
   ByVal tableColumnEndIndex As Integer, _
   ByVal getCells As Boolean, _
   ByVal getRows As Boolean, _
   ByVal getColumns As Boolean, _
   ByVal getObjects As Boolean _
) 
'Usage
 
Dim instance As ISupportFindFormulaDependent
Dim infoDict As Dictionary(Of String,FormulaDependentInfos)
Dim tableName As String
Dim tableColumnStartIndex As Integer
Dim tableColumnEndIndex As Integer
Dim getCells As Boolean
Dim getRows As Boolean
Dim getColumns As Boolean
Dim getObjects As Boolean
 
instance.GetDependents(infoDict, tableName, tableColumnStartIndex, tableColumnEndIndex, getCells, getRows, getColumns, getObjects)

Parameters

infoDict
Dictionary of FormulaDependentInfos object that contains all the infomation of all the dependent formula containers. The key in using the dictionary is the data model name that has dependent formula containers.
tableName
Name of the specified table.
tableColumnStartIndex
Table column start index.
tableColumnEndIndex
Table column end index.
getCells
Indicates whether to get all dependent cells.
getRows
Indicates whether to get all dependent rows.
getColumns
Indicates whether to get all dependent columns.
getObjects
Indicates whether to get all dependent expression consumer objects.
Requirements

Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows Server 2012 R2, Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8, Windows 8.1, Windows 10

See Also

Reference

ISupportFindFormulaDependent Interface
ISupportFindFormulaDependent Members
Overload List

 

 


Copyright © GrapeCity, inc. All rights reserved.